<?php

/**
 * This is the model class for table "OVE_RH_FORMULARIO".
 *
 * The followings are the available columns in table 'OVE_RH_FORMULARIO':
 * @property double $ID
 * @property string $TITULO
 * @property double $STATUS
 */
class Formulario extends CActiveRecord
{
	/**
	 * @return string the associated database table name
	 */
	public function tableName()
	{
		return 'OVE_RH_FORMULARIO';
	}

	/**
	 * @return array validation rules for model attributes.
	 */
	public function rules()
	{
		// NOTE: you should only define rules for those attributes that
		// will receive user inputs.
		return array(
			array('TITULO', 'required'),
			array('STATUS', 'numerical'),
			array('TITULO', 'length', 'max'=>150),
			// The following rule is used by search().
			// @todo Please remove those attributes that should not be searched.
			array('ID, TITULO, STATUS', 'safe', 'on'=>'search'),
		);
	}

	/**
	 * @return array relational rules.
	 */
	public function relations()
	{
		// NOTE: you may need to adjust the relation name and the related
		// class name for the relations automatically generated below.
		return array(
		);
	}

	/**
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels()
	{
		return array(
			'ID' => 'ID',
			'TITULO' => 'Titulo',
			'STATUS' => 'Status',
		);
	}

	/**
	 * Retrieves a list of models based on the current search/filter conditions.
	 *
	 * Typical usecase:
	 * - Initialize the model fields with values from filter form.
	 * - Execute this method to get CActiveDataProvider instance which will filter
	 * models according to data in model fields.
	 * - Pass data provider to CGridView, CListView or any similar widget.
	 *
	 * @return CActiveDataProvider the data provider that can return the models
	 * based on the search/filter conditions.
	 */
	public function search()
	{
		// @todo Please modify the following code to remove attributes that should not be searched.

		$criteria=new CDbCriteria;

		$criteria->compare('ID',$this->ID);
		$criteria->compare('TITULO',$this->TITULO,true);
		$criteria->compare('STATUS',$this->STATUS);

		return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
		));
	}

	/**
	 * Returns the static model of the specified AR class.
	 * Please note that you should have this exact method in all your CActiveRecord descendants!
	 * @param string $className active record class name.
	 * @return Formulario the static model class
	 */
	public static function model($className=__CLASS__)
	{
		return parent::model($className);
	}

    /**
     * Adiciona o id que vem do sequencial
     */
    protected function beforeSave()
    {
        if(empty($this->ID))
        {
            if(parent::beforeSave())
            {
                $connection=Yii::app()->db;
                $sql = "select {$this->tableName()}_SEQ.nextVal from dual";
                $result = $connection->createCommand($sql)->queryRow();
                $this->ID = $result['NEXTVAL'];
            }
        }
        return $this->ID;
    }

    public function getFormularioAll()
    {
        return CHtml::listData(Formulario::model()->findAll(),'ID','TITULO');
    }
}
